package com.ruoyi.mall.common.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.data.repository.query.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface DtsHomeMapper {

    //查询今日销售额
    public Double getTodaySales();
    //查询昨日销售额
    public Double getYesterdaySales();
    //查询今日订单数
    public Integer getTodayOrders();
    //查询昨日订单数
    public Integer getYesterdayOrders();
    //查询总用户数
    public Integer getTotalUsers();
    //商品数量
    public Integer getGoodsCount();

    //查询销售额趋势
    List<Map<String, Object>> getSalesTrend(@Param("type") String type);

    //订单状态分布
    List<Map<String, Object>> getOrderStatus();

    //热门商品销售排行
    List<Map<String, Object>> getHotGoods();

    //商品类型数量
    List<Map<String, Object>> getGoodsType();
}




























